#!/usr/bin/env python
# -*- encoding: utf-8 -*-
# Project: spd-sxmcc
"""
@author: lyndon
@time Created on 2018/9/27 11:18
@desc
"""
import cx_Oracle
dsnStr = cx_Oracle.makedsn("47.94.227.14", "1521", "ORCLPDB")
conn = cx_Oracle.connect(user="edb", password="edb123", dsn=dsnStr)
c=conn.cursor()
x=c.execute('select * from EDB.API_INFO p')
print (x.fetchone())
c.close()
conn.close()